SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=4 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+for +sale +clothing' IN BOOLEAN MODE)) AND iCityID IN (6897,6965,7010,6889,10877,13028,6932,7007,6946,6863,6945,6888,10833,6980,10222,6894,6995,6867,10483,13016,10593,10223,10251,13030,10252,6933,10539,6984,16150,10880,10639,10731,6986,10950,16202,10189,6966,6949,10659,10291,6850,11136,6972,10308,6872,6901,10609,6908,6900,6979,16241,13027,16128,6955,6925,11014,10858,10957,6953,13034,10879,10920,6971,10863,6952,10533,10253,11040,10614,6936,10410,10351,6973,10832,11109,10919,10818,7019,7017,7018,16166,10433,10352,10424,10648,10526,10568,6923,10455,10220,10961,10790,10528,10933,11009,10835,7004,10354,10515,6930,10302,10721,10274,10502,10704,10662,10627,6934,10333,6998,10567,10395,10824,10504,10508,10577,10604,10187,11036,10766,11045,10823,11000,10339,10650,10799,10629,10401,10569,10531,10978,10625,10369,10534,10407,16249,10867,11095,10545,11041,10396,11001,11089,10426,11131,6999,10476,10453,16185,6961,10847,7000,10332,6937,10529,11027,6886,10336,6948,6904,11035,11120,10748,10923,11006,10755,10976,16519,10984,10733,10260,11094,10266,10940,10964,10240,11091,10739,10815,11012,10868,11048,10808,10706,10477,11011,10836,10441,10208,10549,11008,10481,6944,10270,10746,10730,10837,10368,10928,10873,10734,10019,10967,10757,10693,10537,10668,10530,10215,10914,10861,16186,13033,10740,10507,13037,10611,6912,10588,10300,16188,10221,10020,10872,10547,10408,10346,11053,11134,10617,9802,10852,10990,10738,7016,10809,10834,11123,10912,10388,10447,10028,10319,9850,11081,10905,9995,10217,10605,10913,10543,10944,9917,10853,10736,10807,11061,10440,10915,10579,10758,11108,10592,10249,10854,10373,10303,9859,10315,10762,10715,6990,10664,10361,6997,16164,11049,10898,10908,11130,9856,6958,10035,10495,10343,6941,10067,10747,10169,10496,11038,10779,10942,10597,9920,10725,10234,11099,11013,11121,10207,10216,10118,10603,10497,10889,10551,10926,10406,11043,10265,10290,10499,10305,10402,11015,9929,10379,10991,10151,10438,10437,11116,6917,11033,9875,10830,10382,10546,9862,10697,10717,10449,6989,10484,10160,10556,10709,10665,10618,10540,11032,10633,10674,11034,10971,10404,10771,10166,10524,9816,10353,10127,10983,9877,10575,10384,11022,10851,11052,11083,10372,10643,10029,10468,10780,10243,10896,9876,10581,16198,11112,10008,16575,10770,10778,10724,10689,10735,10783,6922,10259,10214,10391,10478,10467,10081,10219,10580,10471,13031,11065,10752,10781,10726,11003,10389,10607,10570,11093,10769,10801,11084,9976,10188,10691,10066,10334,10708,10705,9800,10789,9931,10116,10200,10536,6903,10058,11031,10857,10784,10772,10469,10997,10445,10133,10714,10640,16126,16156,9894,10226,11133,10782,10814,10498,9962,10034,11090,11059,10342,10876,11068,10677,10676,10179,10972,10881,10458,10227,10870,10729,10963,10392,10064,10831,10932,16159,11097,10462,9823,10032,10909,9909,9983,10397,10523,10974,11010,10228,10941,10381,9872,10432,10224,10218,10423,6994,10621,10242,9989,10072,10063,10996,10555,16112,11057,16113,10695,10202,10347,10855,6957,16152,9846,9905,7006,10062,10661,10583,10788,10281,10669,10773,10161,10461,10548,6876,10544,9967,10082,10192,9882,10203,9884,9970,10890,10267,10904,16119,10420,10599,10532,9996,10666,11126,9921,10229,9874,10450,10954,10065,11042,10655,10013,6911,10280,16157,9896,9919,6919,10584,10204,10683,10630,10895,9908,9900,10911,10698,10804,10979,6931,10328,10314,10679,10400,11004,10145,10158,10015,10652,10056,10987,11054,10675,10541,10723,10535,9838,10542,10510,10213,10572,6895,10882,11122,9914,10038,10479,10134,10125,9868,10825,10140,10680,10037,11124,10505,10897,10718,10088,11055,6924,10080,16144,10299,11113,10297,10276,10209,10023,10563,10405,10578,10860,10358,10899,6960,10522,10574,13040,10631,10793,9848,10394,10393,10147,10120,9932,10636,13038,6856,7011,10409,10900,10135,9973,10185,10485,10316,10651,10049,10759,6938,10754,10436,11064,10446,10021,16588,10271,9966,10269,6909,10194,16225,10012,9832,10068,10413,10286,13036,10126,10383,10442,9812,10094,10585,10144,16158,10261,10139,9939,10628,9821,10191,10829,10268,10443,7015,9841,11102,9820) ORDER BY FIELD(iCityID, 6897,6965,7010,6889,10877,13028,6932,7007,6946,6863,6945,6888,10833,6980,10222,6894,6995,6867,10483,13016,10593,10223,10251,13030,10252,6933,10539,6984,16150,10880,10639,10731,6986,10950,16202,10189,6966,6949,10659,10291,6850,11136,6972,10308,6872,6901,10609,6908,6900,6979,16241,13027,16128,6955,6925,11014,10858,10957,6953,13034,10879,10920,6971,10863,6952,10533,10253,11040,10614,6936,10410,10351,6973,10832,11109,10919,10818,7019,7017,7018,16166,10433,10352,10424,10648,10526,10568,6923,10455,10220,10961,10790,10528,10933,11009,10835,7004,10354,10515,6930,10302,10721,10274,10502,10704,10662,10627,6934,10333,6998,10567,10395,10824,10504,10508,10577,10604,10187,11036,10766,11045,10823,11000,10339,10650,10799,10629,10401,10569,10531,10978,10625,10369,10534,10407,16249,10867,11095,10545,11041,10396,11001,11089,10426,11131,6999,10476,10453,16185,6961,10847,7000,10332,6937,10529,11027,6886,10336,6948,6904,11035,11120,10748,10923,11006,10755,10976,16519,10984,10733,10260,11094,10266,10940,10964,10240,11091,10739,10815,11012,10868,11048,10808,10706,10477,11011,10836,10441,10208,10549,11008,10481,6944,10270,10746,10730,10837,10368,10928,10873,10734,10019,10967,10757,10693,10537,10668,10530,10215,10914,10861,16186,13033,10740,10507,13037,10611,6912,10588,10300,16188,10221,10020,10872,10547,10408,10346,11053,11134,10617,9802,10852,10990,10738,7016,10809,10834,11123,10912,10388,10447,10028,10319,9850,11081,10905,9995,10217,10605,10913,10543,10944,9917,10853,10736,10807,11061,10440,10915,10579,10758,11108,10592,10249,10854,10373,10303,9859,10315,10762,10715,6990,10664,10361,6997,16164,11049,10898,10908,11130,9856,6958,10035,10495,10343,6941,10067,10747,10169,10496,11038,10779,10942,10597,9920,10725,10234,11099,11013,11121,10207,10216,10118,10603,10497,10889,10551,10926,10406,11043,10265,10290,10499,10305,10402,11015,9929,10379,10991,10151,10438,10437,11116,6917,11033,9875,10830,10382,10546,9862,10697,10717,10449,6989,10484,10160,10556,10709,10665,10618,10540,11032,10633,10674,11034,10971,10404,10771,10166,10524,9816,10353,10127,10983,9877,10575,10384,11022,10851,11052,11083,10372,10643,10029,10468,10780,10243,10896,9876,10581,16198,11112,10008,16575,10770,10778,10724,10689,10735,10783,6922,10259,10214,10391,10478,10467,10081,10219,10580,10471,13031,11065,10752,10781,10726,11003,10389,10607,10570,11093,10769,10801,11084,9976,10188,10691,10066,10334,10708,10705,9800,10789,9931,10116,10200,10536,6903,10058,11031,10857,10784,10772,10469,10997,10445,10133,10714,10640,16126,16156,9894,10226,11133,10782,10814,10498,9962,10034,11090,11059,10342,10876,11068,10677,10676,10179,10972,10881,10458,10227,10870,10729,10963,10392,10064,10831,10932,16159,11097,10462,9823,10032,10909,9909,9983,10397,10523,10974,11010,10228,10941,10381,9872,10432,10224,10218,10423,6994,10621,10242,9989,10072,10063,10996,10555,16112,11057,16113,10695,10202,10347,10855,6957,16152,9846,9905,7006,10062,10661,10583,10788,10281,10669,10773,10161,10461,10548,6876,10544,9967,10082,10192,9882,10203,9884,9970,10890,10267,10904,16119,10420,10599,10532,9996,10666,11126,9921,10229,9874,10450,10954,10065,11042,10655,10013,6911,10280,16157,9896,9919,6919,10584,10204,10683,10630,10895,9908,9900,10911,10698,10804,10979,6931,10328,10314,10679,10400,11004,10145,10158,10015,10652,10056,10987,11054,10675,10541,10723,10535,9838,10542,10510,10213,10572,6895,10882,11122,9914,10038,10479,10134,10125,9868,10825,10140,10680,10037,11124,10505,10897,10718,10088,11055,6924,10080,16144,10299,11113,10297,10276,10209,10023,10563,10405,10578,10860,10358,10899,6960,10522,10574,13040,10631,10793,9848,10394,10393,10147,10120,9932,10636,13038,6856,7011,10409,10900,10135,9973,10185,10485,10316,10651,10049,10759,6938,10754,10436,11064,10446,10021,16588,10271,9966,10269,6909,10194,16225,10012,9832,10068,10413,10286,13036,10126,10383,10442,9812,10094,10585,10144,16158,10261,10139,9939,10628,9821,10191,10829,10268,10443,7015,9841,11102,9820) ASC, p.tmPosted DESC LIMIT 24 OFFSET 24 for sale clothing, For Sale Classifieds, Buy Used, Electronics, Computers, Tablets, Mobiles in Georgetown, Page 2

Items for sale in Georgetown - for sale clothing

Show more results

By Using this website, you agree to Terms of Use & Privacy Policy. Got it